Untitled


Voting Record
It is recommended that you set your printer to Landscape format when printing this report.
02/20/2024 - City Council Meeting - FINAL
Passed 6.A.  Consideration of Appointments:  Audit Committee
Motion:  to appoint John Cortese to the Audit Committee.
Passed 6.A.  Consideration of Appointments:  Audit Committee
Motion:  to appoint Jennifer Stevenson to the Audit Committee.
Passed 7.A.  Consideration and Action on Liquor License Application: Amy S. Nations, "Whispering Winds Motor Hotel," 922 E. Route 66, Series 07 (Beer and Wine Bar), Location/Owner Transfer.
Motion:  to forward the application to the State with a recommendation for approval.
Passed 7.A.  Consideration and Action on Liquor License Application: Amy S. Nations, "Whispering Winds Motor Hotel," 922 E. Route 66, Series 07 (Beer and Wine Bar), Location/Owner Transfer.
Motion:  to forward the application to the State with a recommendation for approval with the stipulation that no single serving mini bottles will not be provided at this location.
Passed 7.B.  Consideration and Action on Liquor License Application: Rafael Galvan, Jr., "Family Dollar #28851," 5060 US-89, Series 10 (beer and wine store), New License.
Passed 8.  CONSENT AGENDA
 
All matters under Consent Agenda are considered by the City Council to be routine. Unless a member of City Council expresses a desire at the meeting to remove an item from the Consent Agenda for discussion, the Consent Agenda will be enacted by one motion approving the recommendations listed on the agenda. Unless otherwise indicated, expenditures approved by Council are budgeted items.
Passed 9.A.  Consideration and Approval of Contract:  Consideration and Approval of the Third Amendment for GMP 4, for Construction and Repair Services for the Inner Basin Waterline Restoration Project
Passed 9.B.  Consideration and Adoption of Ordinance No. 2024-04: An ordinance of the City Council of the City of Flagstaff, authorizing the exchange of real property of substantially equal value with a property owner, ZH Holdings Butler, LLC; providing for delegation of authority, severability, repeal of conflicting ordinances, and establishing an effective date

Consideration and Approval of Purchase Agreement with ZH Holdings Butler, LLC
Motion:  to read Ordinance No. 2024-04 by title only for the final time.
Passed 9.B.  Consideration and Adoption of Ordinance No. 2024-04: An ordinance of the City Council of the City of Flagstaff, authorizing the exchange of real property of substantially equal value with a property owner, ZH Holdings Butler, LLC; providing for delegation of authority, severability, repeal of conflicting ordinances, and establishing an effective date

Consideration and Approval of Purchase Agreement with ZH Holdings Butler, LLC
Motion:  to adopt Ordinance No. 2024-04.
Passed 9.C.  Consideration and Approval of Final Plat Request by Brookfield Communities, Inc. for Final Plat approval for Woodshire on Butler Condominiums, a 50-unit residential condominium subdivision. (Subdivision of approximately 4.06 acres into 50 condominiums located at 2989 and 3001 E. Butler Avenue)
Passed 10.A.  Consideration and Adoption of Resolution No. 2024-08:  A resolution of the Flagstaff City Council, authorizing the grant agreement for an Arizona State Parks Heritage Fund - Environmental Education grant, agreement # 632407, for the continuation of the Open Space Education Coordinator position to provide outdoor environmental programs for the community, for an additional two years.
Motion:  to read Resolution No. 2024-08 by title only.
Passed 10.A.  Consideration and Adoption of Resolution No. 2024-08:  A resolution of the Flagstaff City Council, authorizing the grant agreement for an Arizona State Parks Heritage Fund - Environmental Education grant, agreement # 632407, for the continuation of the Open Space Education Coordinator position to provide outdoor environmental programs for the community, for an additional two years.
Motion:  to adopt Resolution No. 2024-08.
Passed 10.A.  Consideration and Adoption of Resolution No. 2024-08:  A resolution of the Flagstaff City Council, authorizing the grant agreement for an Arizona State Parks Heritage Fund - Environmental Education grant, agreement # 632407, for the continuation of the Open Space Education Coordinator position to provide outdoor environmental programs for the community, for an additional two years.
Motion:  to authorize the grant agreement with the Arizona State Parks Board for the Heritage Fund Environmental Education grant program, for grant funds in the amount of $119,724 with a city match of $15,500, for the continuation of the Open Space Education Coordinator position to provide outdoor environmental programs for the community.
Passed 10.B.  Consideration and Adoption of Resolution No. 2024-02: A resolution of the Flagstaff City Council, approving an Intergovernmental Agreement among the Coconino County Free Library District and the City of Flagstaff, the City of Williams, the City of Page, the Town of Fredonia, the City of Sedona, and Coconino County for the administration and funding of branch and affiliate libraries within the Coconino County Free Library District, and establishing an effective date
Motion:  to read Resolution No. 2024-02 by title only.
Passed 10.B.  Consideration and Adoption of Resolution No. 2024-02: A resolution of the Flagstaff City Council, approving an Intergovernmental Agreement among the Coconino County Free Library District and the City of Flagstaff, the City of Williams, the City of Page, the Town of Fredonia, the City of Sedona, and Coconino County for the administration and funding of branch and affiliate libraries within the Coconino County Free Library District, and establishing an effective date
Motion:  to adopt Resolution No. 2024-02.
Passed 10.C.  Consideration and Adoption of Resolution No. 2024-09: A resolution of the Flagstaff City Council, authorizing the acquisition of real property interests necessary for the Rio De Flag Flood Control Project, a public use; providing for delegation of authority, condemnation authority, repeal of conflicting resolutions, and establishing an effective date
Motion:  to read Resolution No. 2024-09 by title only.
Passed 10.C.  Consideration and Adoption of Resolution No. 2024-09: A resolution of the Flagstaff City Council, authorizing the acquisition of real property interests necessary for the Rio De Flag Flood Control Project, a public use; providing for delegation of authority, condemnation authority, repeal of conflicting resolutions, and establishing an effective date
Motion:  to adopt Resolution No. 2024-09.
Passed 10.D.  Consideration and Adoption of Ordinance 2024-05: An ordinance of the City Council of the City of Flagstaff authorizing the acquisition of real property for the Killip Inlet as part of the Spruce Wash Channel Improvements Project; providing for delegation of authority, repeal of conflicting ordinances, severability, clerical corrections, and establishing an effective date
Passed 10.E.  Consideration and Possible Action: Use of the Council Initiative Fund


Debugging Information
ColdFusion Server Standard 2016,0,16,320445
Template /officials.cfm
Time Stamp 29-Apr-24 08:55 PM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 10.20.230.5
Host Name 10.20.230.5


Execution Time

Total Time Avg Time Count Template
942 ms 942 ms 1 D:/inetpub/PublicPages/officials.cfm
910 ms 910 ms 1 D:/inetpub/PublicPages/meetingOfficials.cfm
326 ms 12 ms 27 D:/inetpub/PublicPages/public/publish/include_levels.cfm
16 ms 8 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
16 ms 16 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/Application.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/blueMenu.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/menu_tabs.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/agenda_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/user_attr.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/utilities.cfm
0 ms 0 ms 27 D:/inetpub/PublicPages/public/publish/clean_subject.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/customHeader.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_head.cfm
15 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
957 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

chkForExtraFlds (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 20:55:49.049
			select * from codes c where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
		
getTZOffset (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 20:55:49.049
				select c.misc_alpha9 tz, c2.misc_alpha tz_offset
				from codes c
				left outer join codes as c2 on (c2.code_type = 'TIMEZONE' and c2.valid_code = c.misc_alpha9)
				where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
			
chkForExtraFlds (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 20:55:49.049
			select * from codes c where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
		
getTZOffset (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 20:55:49.049
				select c.misc_alpha9 tz, c2.misc_alpha tz_offset
				from codes c
				left outer join codes as c2 on (c2.code_type = 'TIMEZONE' and c2.valid_code = c.misc_alpha9)
				where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
			
chkSite (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\officials.cfm @ 20:55:49.049
		SELECT dist_name FROM fasinfo
	
codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 20:55:49.049
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 20:55:49.049
		SELECT mt.meeting_type, mt.descr, c.long_descr notify_public
		FROM meeting_type mt
		LEFT OUTER JOIN codes c ON (c.code_type = 'MTG_MSG' AND c.valid_code = mt.meeting_type)
		WHERE mt.show_public = 'Y'
			
		ORDER BY mt.descr
	
useNotify (Datasource=, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 20:55:49.049
	SELECT notify_public FROM meetingTypes WHERE notify_public = 'Y'
contactInfo (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 20:55:49.049
		select text_value1 notify_public_contact, long_descr confLink
		from codes
		where codes.code_type = 'AddlSetup' and codes.valid_code = 'EmailSub'
	
chkAddlSetup (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 20:55:49.049
	SELECT * from codes WHERE code_type = 'AddlSetup' AND valid_code = 'SysSetup'
chkAddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 20:55:49.049
	SELECT c.*,
	 	c.misc_alpha6 subscribe_tab, c.misc_alpha7 officials_tab, c.misc_alpha8 ordinance_tab, c.misc_alpha9 resolution_tab,
	 	c.misc_alpha11 voting_tab, c.misc_alpha12 useTabs, c.datasortOrder noOfMonths, c.loc_code ApplyTab,
	 	c.misc_alpha14 otherTab, c.misc_alpha15 oth_tab_descr, c1.misc_alpha3 other_doc_type,
 		c1.misc_alpha tab_color, c1.misc_alpha2 time_period, c1.misc_alpha4 sort_res_ord,
 		c1.misc_alpha5 ord_tab_descr, c1.misc_alpha6 res_tab_descr
 	from codes c
    LEFT OUTER JOIN codes c1 ON (c1.code_type = 'AddlSetup' AND c1.valid_code = 'SysSetup3')
	WHERE c.code_type = 'AddlSetup' AND c.valid_code = 'SysSetup2'
contactInfo (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 20:55:49.049
		select text_value1 notify_public_contact, long_descr confLink
		from codes
		where codes.code_type = 'AddlSetup' and codes.valid_code = 'EmailSub'
MeetingInfo (Datasource=frsRO, Time=0ms, Records=8) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 20:55:49.049
		select valid_code
		from codes
		where codes.code_type = 'MTG_MSG' and codes.misc_alpha15 = 'Y'
fasinfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 20:55:49.049
	SELECT user_filedir_alias, min_dir_alias, use_minutes, use_agendaquick,
		srch_engine, isys_path, dflt_verity_coll, hart_version, user_defined
	FROM fasinfo
getFasInfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 20:55:49.049
	select fasinfo.*,
	       c3.large_misc_alpha external_prefix, c3.misc_alpha2 active_directory, c3.misc_alpha3 ad_custsfx,
	       c3.loc_code allowExtNotes, c3.misc_alpha4 hostedInstall, c3.descr publTimeout, c3.text_value2 hosted_code
	from fasinfo
	left outer join codes as c3 on (c3.code_type = 'AddlSetup' and c3.valid_code = 'SysSetup')
AddlSetup (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 20:55:49.049
	select text_value1, misc_alpha public_window, loc_code allowExtNotes
	from codes where code_type = 'AddlSetup' and valid_code = 'SysSetup'
begin_year (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 20:55:49.049
	SELECT MIN(fis_yr) fis_yr FROM fas
	WHERE form_id = 'AGENDA'
end_year (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 20:55:49.049
	SELECT MAX(fis_yr) fis_yr
	FROM fas
	WHERE form_id = 'AGENDA' AND final_apprvl = 'Y'
begin_collection (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 20:55:49.049
	SELECT MIN(coll_name) coll_name FROM verity_collections
	ORDER BY coll_name
all_userdef (Datasource=frsRO, Time=0ms, Records=58) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 20:55:49.049
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 20:55:49.049
	SELECT c.code_type, c.valid_code, c.descr, c.obsolete, c.misc_alpha2, c.descr, c.dataSortOrder sort_order,
		CASE WHEN descr = '' THEN valid_code ELSE descr END AS time_descr
	FROM codes c
	WHERE c.code_type = 'AG TIME'
	
		OR code_type IN ('ud_tb1','ud_pd1','ud_cb1','ud_ta1','ud_ta2','ud_fi1','ud_fi1','ud_cb1','ud_fi3','ud_fi4','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_yn1','ud_fi12','ud_fi13','ud_tb2','ud_fi2','ud_dt1','ud_fims1','ud_fil1','ud_fi3','ud_fis1','ud_tb3','ud_fi4','ud_tb4','ud_tb5','ud_tb6','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_fi10','ud_fi11','ud_fi12','ud_fi13','ud_fi14','ud_fi15','ud_fi16','ud_fi17','ud_fi18','ud_fi19','ud_fi20','ud_fi21','ud_fi22','ud_fi23','ud_dt1','ud_fi14','ud_fi15','ud_dt2','ud_rs1','ud_fi24','ud_fi25','ud_tb7','ud_fi26')
		AND (opt_form_id = '' OR opt_form_id IS NULL)
	
get_agendas (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 20:55:49.049
		SELECT m.meeting_dt, m.meeting_name, m.meeting_id, a.form_num as ag_form_num,
			minutes.minutes_published, a.agenda_published,
			a.minutes_doc_name, a.minutes_doc_link,	a.default_doc_dir,
			minutes.default_doc_dir minutes_default_doc_dir,
			a.packet_doc_name, a.packet_published,
			minutes.form_num as min_form_num, minutes.minutes_packet_published,
			minutes.minutes_packet_name,
			ag_links.link_label as ag_link_label, ag_links.link_url as ag_link_url,
			min_links.link_label as min_link_label, min_links.link_url as min_link_url,
			 rel.large_misc_alpha as release_date, agt.meeting_type
		FROM meetings AS m
		INNER JOIN agenda AS a ON ( 
			a.meeting_id = m.meeting_id AND
			(a.agenda_published = 'Y' OR a.packet_published = 'Y')
		)
		LEFT OUTER JOIN minutes ON (
			minutes.meeting_id = m.meeting_id AND
			(minutes.minutes_published = 'Y' OR minutes.minutes_packet_published = 'Y')
		)
		INNER JOIN ag_template AS agt ON (agt.ag_template_id = m.template_id
		
			AND agt.meeting_type IN ('AIR','BOA','SALARY','CCBUDG','CCCSMWS','CCMTG','CCES','CCJWS','CCMTGF','CCSCM','CCSWS','CCWS','DVA','DA','FB','HPC','HOUS','IND','PQ','OSC','PR','PZ','PSPRS','SUS')
		
		)
		LEFT OUTER JOIN codes as rel ON (rel.code_type = 'AddlMtg' AND CAST(rel.valid_code AS INT) = m.meeting_id)
		
		LEFT OUTER JOIN form_links AS ag_links ON (
			ag_links.form_id  = 'AGENDA' AND
			ag_links.form_num = a.form_num AND
			ag_links.link_seq = 1
		)
		LEFT OUTER JOIN form_links AS min_links ON (
			min_links.form_id  = 'MINUTES' AND
			min_links.form_num = minutes.form_num AND
			min_links.rev_num  = minutes.rev_num AND
			min_links.link_seq = 1
		)
		WHERE m.meeting_dt >= ?

		  AND m.meeting_dt <= ?

		ORDER BY m.meeting_dt DESC, m.meeting_name
		
Query Parameter Value(s) -
Parameter #1(cf_sql_timestamp) = 2024-04-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2024-05-16 00:00:00.0

pageTitle (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:49.049
	SELECT menu_label FROM fas_menu WHERE web_page = '../fas/term_report.cfm'
fasinfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:49.049
	SELECT * FROM fasinfo
get_fasinfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:49.049
	SELECT use_minutes, use_agendaquick, term_remind_days, c.misc_alpha4 hosted
	FROM fasinfo
	LEFT OUTER JOIN codes c ON (c.code_type = 'AddlSetup' AND c.valid_code = 'SysSetup')
checkCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:49.049
	SELECT * from codes WHERE code_type = 'FORM_ID' AND valid_code = 'AG_MEMO'
OfficialsMeetingTypes (Datasource=frsRO, Time=0ms, Records=8) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:49.049
	SELECT mt.meeting_type, mt.descr, c.long_descr notify_public, c.misc_alpha15 meetingOfficials
	FROM meeting_type mt
	INNER JOIN codes c ON (c.code_type = 'MTG_MSG' AND c.valid_code = mt.meeting_type)
	WHERE mt.show_public = 'Y' and c.misc_alpha15 = 'Y'
		
	ORDER BY mt.descr
getRecs (Datasource=frsRO, Time=15ms, Records=53) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:49.049
	select tt._rowid tt_rowid, tt.*, codes.valid_code, codes.long_descr, codes.dataSortOrder, mt.descr
	from codes, term_tracker tt
	
		INNER JOIN meeting_type mt ON (mt.meeting_type = tt.meeting_type AND mt.obsolete <> 'Y')
	
	INNER JOIN codes c ON (c.code_type = 'MTG_MSG' AND c.valid_code = tt.meeting_type AND c.misc_alpha15 = 'Y')
	where codes._rowid = tt.code_rowid and	
		  codes.code_type = 'AG_OFF'

	
	      and (tt.term_end >= ? )

	

	order by 
			tt.meeting_type, tt.lname, tt.fname
		
Query Parameter Value(s) -
Parameter #1(cf_sql_timestamp) = 2024-04-29 20:55:49.944

getRecsCount (Datasource=, Time=0ms, Records=53) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:49.049
	SELECT * from getRecs
getRecs2 (Datasource=, Time=0ms, Records=53) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:49.049
	SELECT * from getRecs
getMeetingTypes (Datasource=frsRO, Time=0ms, Records=8) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:49.049
		SELECT mt.meeting_type, mt.descr, c.long_descr notify_public
		FROM meeting_type mt
		LEFT OUTER JOIN codes c ON (c.code_type = 'MTG_MSG' AND c.valid_code = mt.meeting_type)
		WHERE mt.show_public = 'Y' and c.misc_alpha15 = 'Y'
		AND CAST(mt.pdf_header as varchar) <> 'N'
		
	ORDER BY mt.descr
getMinrecs (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:49.049
			SELECT min.form_num, m.meeting_dt, m.meeting_name
			from minutes min, meetings m
			where min.meeting_id = m.meeting_id
				AND m.meeting_dt = ?
			ORDER BY meeting_name, meeting_dt
		
Query Parameter Value(s) -
Parameter #1(cf_sql_date) = 2024-02-20

getVoteTypes (Datasource=frsRO, Time=0ms, Records=5) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:49.049
		SELECT valid_code, descr, long_descr vote_type, misc_alpha absent FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND obsolete <> 'Y'
		order by datasortorder
	
getMinrecs (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:49.049
						SELECT min.form_num, m.meeting_dt, m.meeting_name
						from minutes min, meetings m
						where min.meeting_id = m.meeting_id
							AND min.minutes_published = 'Y'
							AND m.meeting_dt = ?
						ORDER BY meeting_name, meeting_dt
					
Query Parameter Value(s) -
Parameter #1(cf_sql_date) = 2024-02-20

getMinLines (Datasource=frsRO, Time=63ms, Records=27) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
								SELECT a.cont_numbering, a.form_num minutes_form_num, am.form_num fas_form_num, am.ag_item_rowid,
									   ml._rowid ln_rowid, ml._rowid min_ln_rowid, ml.form_num, ml.seq_num,
									   am.ag_item_rowid, ml.ag_level1 chk_level1, ml.ag_level2 chk_level2, ml.ag_level3 chk_level3,
									   ml.ag_level1, ml.ag_level2, ml.ag_level3, ml.ag_level4, ml.disp_level, am.ainumber,
									   as1.sort_seq sort_level1, ml.ag_memo_id, ml.ag_memo_rev, c1.descr ag_time_descr,
									   fas.routing_apprvl fas_routing_apprvl, fas.final_apprvl fas_final_apprvl,
									   aa.item_type, aa.ag_area, ml.ag_subject,
									   c4.misc_alpha2 level_descriptor,
									   c2.misc_alpha7 lvl_text_size, c2.misc_alpha6 dp_level_ai, c3.long_descr px_size, c3.descr pdf_format,
											mt.agmemo_prefix, mt.agmemo_desc, a.disp_ainumber,
									   CASE WHEN am.ainumber = '' then '-1'
										WHEN am.ainumber = '0' then '-1'
										WHEN am.ainumber IS NULL then '-1'
								        ELSE am.ainumber END AS sort_memo2,
									    am.ag_item_rowid,
									   CASE WHEN ml.ag_level2 != '' AND ml.ag_level2 != '0' THEN as2.sort_seq ELSE -1 END AS sort_level2,
									   CASE WHEN ml.ag_level3 != '' AND ml.ag_level3 != '0' THEN as3.sort_seq ELSE -1 END AS sort_level3,
									   CASE WHEN ml.ag_level4 != '' AND ml.ag_level4 != '0' THEN as4.sort_seq ELSE -1 END AS sort_level4,
									   CASE WHEN ml.ag_memo_id IS NOT NULL THEN ml.ag_memo_id ELSE -1 END AS sort_memo,
									   CASE WHEN ml.ag_memo_id IS NOT NULL THEN am.ag_time ELSE ml.ag_time END as ag_time
								FROM minutes_ln ml
								INNER JOIN minutes a ON (a.form_num = ml.form_num AND a.rev_num = ml.rev_num)

								LEFT OUTER JOIN ag_memo AS am ON (am.form_num = ml.ag_memo_id AND am.rev_num = ml.ag_memo_rev)
								LEFT OUTER JOIN ag_template AS agt ON (agt.ag_template_id = a.ag_template_id)
								LEFT OUTER JOIN meeting_type AS mt ON (mt.meeting_type = agt.meeting_type)
								LEFT OUTER JOIN fas ON (fas.form_id = 'AG_MEMO' AND fas.form_num = am.form_num AND fas.rev_num = am.rev_num)
								
								LEFT OUTER JOIN ag_item AS ai ON (ai._rowid = am.ag_item_rowid)
								
								LEFT OUTER JOIN agenda_ln AS al ON (al.ag_memo_id = am.form_num AND al.ag_memo_rev = am.rev_num)
								LEFT OUTER JOIN ag_area AS aa ON (aa.meeting_type = agt.meeting_type AND aa.ag_area = ml.ag_area)          
								LEFT OUTER JOIN codes AS c1 ON (c1.code_type = 'AG TIME' and c1.valid_code = am.ag_time)
								LEFT OUTER JOIN alpha_sort AS as1 ON (as1.alpha_value = ml.ag_level1 AND CAST(as1.alpha_value AS binary(8)) = CAST(ml.ag_level1 AS binary(8)))
								LEFT OUTER JOIN alpha_sort AS as2 ON (as2.alpha_value = ml.ag_level2 AND CAST(as2.alpha_value AS binary(8)) = CAST(ml.ag_level2 AS binary(8)))
								LEFT OUTER JOIN alpha_sort AS as3 ON (as3.alpha_value = ml.ag_level3 AND CAST(as3.alpha_value AS binary(8)) = CAST(ml.ag_level3 AS binary(8)))
								LEFT OUTER JOIN alpha_sort AS as4 ON (as4.alpha_value = ml.ag_level4 AND CAST(as4.alpha_value AS binary(8)) = CAST(ml.ag_level4 AS binary(8)))
								LEFT OUTER JOIN codes AS c2 ON (c2.code_type = 'AddlMtg' and CAST(c2.valid_code AS INT) = a.meeting_id)
								LEFT OUTER JOIN codes AS c3 ON (c3.code_type = 'AG_FONT' and c3.valid_code = a.text_size)
								LEFT OUTER JOIN codes AS c4 ON (c4.code_type = 'MTG_MSG' and c4.valid_code = mt.meeting_type)
								WHERE ml.form_num = 1046
								ORDER BY sort_level1, sort_level2, sort_level3, sort_level4, sort_memo2, sort_memo, ln_rowid
							
checkVoteParent (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
							SELECT DISTINCT ag_area, item_type FROM getMinLines WHERE item_type = 'Y'
						
getAllVotes (Datasource=frsRO, Time=298ms, Records=133) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
							SELECT mlv.form_num, ml.form_num minutes_form_num, ml._rowid min_ln_rowid,
									mlv.valid_code, mlv.motion_seq, mlv.seq_num, mlv.motion_rowid,
									ml.ag_memo_id, ml.ag_memo_rev, ml.ag_subject, mlm.motion_status, mlm.ln_rowid,
									c1.descr voteDescr, vote, c.descr, c1.long_descr vote_type, c1.misc_alpha abs_vote, tt.lname
							from minutes_ln_vote mlv
							INNER JOIN minutes_ln ml ON (ml._rowid = mlv.ln_rowid)
							INNER JOIN minutes_ln_motion mlm ON (mlm.ln_rowid = mlv.ln_rowid AND mlm.motion_seq = mlv.motion_seq)
							INNER JOIN codes c1 ON (c1.code_type = 'AG_VOTEOTHER' AND c1.valid_code = mlv.vote)
						
							LEFT OUTER JOIN codes c ON (c.code_type = 'AG_OFF' AND c.valid_code = mlv.valid_code)
							LEFT OUTER JOIN term_tracker tt ON (tt.code_rowid = c._rowid)
							LEFT OUTER JOIN codes c2 ON (c2.code_type = 'AG_OFF' AND c2.descr = tt.fname + ' ' + tt.lname and
									c2.valid_code = mlv.valid_code AND
									c2.large_misc_alpha = tt.meeting_type)
						    INNER JOIN minutes_roll mr ON (mr.form_num = mlv.form_num AND mr.name = c.descr AND c.large_misc_alpha = tt.meeting_type)
						
							WHERE mlv.form_num = 1046 
								AND (mlv.valid_code = c.valid_code OR c2.large_misc_alpha = c.large_misc_alpha)
							
							order by mlv.form_num, mlv.ln_rowid, mlv.motion_seq, mlv.seq_num, mlv.valid_code
						
totalVotes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
						SELECT voteDescr, count(voteDescr) voteCount
						FROM getAllVotes group by voteDescr
					
getType (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
		SELECT * from getVoteTypes WHERE getVoteTypes.descr = 'AYE'
	
getMeetingVoters (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
							SELECT DISTINCT lname, valid_code, descr from getAllVotes
							WHERE form_num = 1046
							order by lname
						
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT * from getAllVotes WHERE ln_rowid = 22051 
getMyMotions (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 1046 AND
											ln_rowid = 22051 
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
		SELECT meeting_id FROM minutes WHERE form_num = 1046 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 20:55:50.050
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3966

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT * from getMinLines
					WHERE ln_rowid = 22051 
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT * from getAllVotes WHERE ln_rowid = 22055 
getMyMotions (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 1046 AND
											ln_rowid = 22055 
getform (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
		SELECT meeting_id FROM minutes WHERE form_num = 1046 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 20:55:50.050
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3966

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT * from getMinLines
					WHERE ln_rowid = 22055 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '1'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '1'
					AND a.ag_level2 = ''
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '1'
					AND a.ag_level2 = ''
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT * from getAllVotes WHERE ln_rowid = 22063 
getMyMotions (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 1046 AND
											ln_rowid = 22063 
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
		SELECT meeting_id FROM minutes WHERE form_num = 1046 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 20:55:50.050
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3966

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT * from getMinLines
					WHERE ln_rowid = 22063 
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT * from getAllVotes WHERE ln_rowid = 22052 
getMyMotions (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 1046 AND
											ln_rowid = 22052 
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
		SELECT meeting_id FROM minutes WHERE form_num = 1046 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 20:55:50.050
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3966

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT * from getMinLines
					WHERE ln_rowid = 22052 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '2'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '2'
					AND a.ag_level2 = ''
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '2'
					AND a.ag_level2 = ''
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT * from getAllVotes WHERE ln_rowid = 22059 
getMyMotions (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 1046 AND
											ln_rowid = 22059 
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
		SELECT meeting_id FROM minutes WHERE form_num = 1046 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 20:55:50.050
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3966

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT * from getMinLines
					WHERE ln_rowid = 22059 
chkLevel1 (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '3'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '3'
					AND a.ag_level2 = ''
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '3'
					AND a.ag_level2 = ''
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT * from getAllVotes WHERE ln_rowid = 22053 
getMyMotions (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 1046 AND
											ln_rowid = 22053 
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
		SELECT meeting_id FROM minutes WHERE form_num = 1046 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 20:55:50.050
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3966

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT * from getMinLines
					WHERE ln_rowid = 22053 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '4'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '4'
					AND a.ag_level2 = ''
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '4'
					AND a.ag_level2 = ''
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT * from getAllVotes WHERE ln_rowid = 22064 
getMyMotions (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 1046 AND
											ln_rowid = 22064 
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
		SELECT meeting_id FROM minutes WHERE form_num = 1046 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 20:55:50.050
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3966

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT * from getMinLines
					WHERE ln_rowid = 22064 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '5'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '5'
					AND a.ag_level2 = ''
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '5'
					AND a.ag_level2 = ''
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT * from getAllVotes WHERE ln_rowid = 22054 
getMyMotions (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 1046 AND
											ln_rowid = 22054 
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
		SELECT meeting_id FROM minutes WHERE form_num = 1046 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 20:55:50.050
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3966

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT * from getMinLines
					WHERE ln_rowid = 22054 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '6'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '6'
					AND a.ag_level2 = ''
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '6'
					AND a.ag_level2 = ''
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotes (Datasource=, Time=0ms, Records=14) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT * from getAllVotes WHERE ln_rowid = 22066 
getMyMotions (Datasource=frsRO, Time=16ms, Records=2) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 1046 AND
											ln_rowid = 22066 
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
		SELECT meeting_id FROM minutes WHERE form_num = 1046 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 20:55:50.050
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3966

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT * from getMinLines
					WHERE ln_rowid = 22066 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '6'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '6'
					AND a.ag_level2 = 'A'
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '6'
					AND a.ag_level2 = 'A'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotesNow (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
													SELECT * from getMyVotes WHERE
														(motion_rowid = 4781 OR motion_seq = 2)
												
getMyVotesNow (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
													SELECT * from getMyVotes WHERE
														(motion_rowid = 4782 OR motion_seq = 3)
												
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT * from getAllVotes WHERE ln_rowid = 22056 
getMyMotions (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 1046 AND
											ln_rowid = 22056 
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
		SELECT meeting_id FROM minutes WHERE form_num = 1046 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 20:55:50.050
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3966

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT * from getMinLines
					WHERE ln_rowid = 22056 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '7'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '7'
					AND a.ag_level2 = ''
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '7'
					AND a.ag_level2 = ''
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotes (Datasource=, Time=0ms, Records=14) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT * from getAllVotes WHERE ln_rowid = 22067 
getMyMotions (Datasource=frsRO, Time=15ms, Records=2) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 1046 AND
											ln_rowid = 22067 
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
		SELECT meeting_id FROM minutes WHERE form_num = 1046 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 20:55:50.050
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3966

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT * from getMinLines
					WHERE ln_rowid = 22067 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '7'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '7'
					AND a.ag_level2 = 'A'
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '7'
					AND a.ag_level2 = 'A'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotesNow (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
													SELECT * from getMyVotes WHERE
														(motion_rowid = 4783 OR motion_seq = 2)
												
getMyVotesNow (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
													SELECT * from getMyVotes WHERE
														(motion_rowid = 4784 OR motion_seq = 3)
												
getMyVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT * from getAllVotes WHERE ln_rowid = 22068 
getMyMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 1046 AND
											ln_rowid = 22068 
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
		SELECT meeting_id FROM minutes WHERE form_num = 1046 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 20:55:50.050
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3966

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT * from getMinLines
					WHERE ln_rowid = 22068 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '7'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '7'
					AND a.ag_level2 = 'B'
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '7'
					AND a.ag_level2 = 'B'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT * from getAllVotes WHERE ln_rowid = 22057 
getMyMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 1046 AND
											ln_rowid = 22057 
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
		SELECT meeting_id FROM minutes WHERE form_num = 1046 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 20:55:50.050
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3966

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT * from getMinLines
					WHERE ln_rowid = 22057 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '8'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '8'
					AND a.ag_level2 = ''
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '8'
					AND a.ag_level2 = ''
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT * from getAllVotes WHERE ln_rowid = 22069 
getMyMotions (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 1046 AND
											ln_rowid = 22069 
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
		SELECT meeting_id FROM minutes WHERE form_num = 1046 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 20:55:50.050
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3966

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT * from getMinLines
					WHERE ln_rowid = 22069 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '8'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '8'
					AND a.ag_level2 = 'A'
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '8'
					AND a.ag_level2 = 'A'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT * from getAllVotes WHERE ln_rowid = 22058 
getMyMotions (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 1046 AND
											ln_rowid = 22058 
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
		SELECT meeting_id FROM minutes WHERE form_num = 1046 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 20:55:50.050
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3966

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT * from getMinLines
					WHERE ln_rowid = 22058 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '9'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '9'
					AND a.ag_level2 = ''
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '9'
					AND a.ag_level2 = ''
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT * from getAllVotes WHERE ln_rowid = 22070 
getMyMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 1046 AND
											ln_rowid = 22070 
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
		SELECT meeting_id FROM minutes WHERE form_num = 1046 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 20:55:50.050
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3966

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT * from getMinLines
					WHERE ln_rowid = 22070 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '9'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '9'
					AND a.ag_level2 = 'A'
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '9'
					AND a.ag_level2 = 'A'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotes (Datasource=, Time=0ms, Records=14) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT * from getAllVotes WHERE ln_rowid = 22071 
getMyMotions (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 1046 AND
											ln_rowid = 22071 
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
		SELECT meeting_id FROM minutes WHERE form_num = 1046 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 20:55:50.050
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3966

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT * from getMinLines
					WHERE ln_rowid = 22071 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '9'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '9'
					AND a.ag_level2 = 'B'
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '9'
					AND a.ag_level2 = 'B'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotesNow (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
													SELECT * from getMyVotes WHERE
														(motion_rowid = 4788 OR motion_seq = 2)
												
getMyVotesNow (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
													SELECT * from getMyVotes WHERE
														(motion_rowid = 4789 OR motion_seq = 4)
												
getMyVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT * from getAllVotes WHERE ln_rowid = 22072 
getMyMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 1046 AND
											ln_rowid = 22072 
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
		SELECT meeting_id FROM minutes WHERE form_num = 1046 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 20:55:50.050
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3966

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT * from getMinLines
					WHERE ln_rowid = 22072 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '9'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '9'
					AND a.ag_level2 = 'C'
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '9'
					AND a.ag_level2 = 'C'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT * from getAllVotes WHERE ln_rowid = 22060 
getMyMotions (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 1046 AND
											ln_rowid = 22060 
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
		SELECT meeting_id FROM minutes WHERE form_num = 1046 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 20:55:50.050
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3966

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT * from getMinLines
					WHERE ln_rowid = 22060 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '10'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '10'
					AND a.ag_level2 = ''
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '10'
					AND a.ag_level2 = ''
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotes (Datasource=, Time=0ms, Records=21) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT * from getAllVotes WHERE ln_rowid = 22073 
getMyMotions (Datasource=frsRO, Time=0ms, Records=3) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 1046 AND
											ln_rowid = 22073 
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
		SELECT meeting_id FROM minutes WHERE form_num = 1046 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 20:55:50.050
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3966

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT * from getMinLines
					WHERE ln_rowid = 22073 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '10'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '10'
					AND a.ag_level2 = 'A'
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '10'
					AND a.ag_level2 = 'A'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotesNow (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
													SELECT * from getMyVotes WHERE
														(motion_rowid = 4791 OR motion_seq = 2)
												
getMyVotesNow (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
													SELECT * from getMyVotes WHERE
														(motion_rowid = 4792 OR motion_seq = 4)
												
getMyVotesNow (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
													SELECT * from getMyVotes WHERE
														(motion_rowid = 4793 OR motion_seq = 5)
												
getMyVotes (Datasource=, Time=0ms, Records=14) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT * from getAllVotes WHERE ln_rowid = 22074 
getMyMotions (Datasource=frsRO, Time=3ms, Records=2) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 1046 AND
											ln_rowid = 22074 
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
		SELECT meeting_id FROM minutes WHERE form_num = 1046 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 20:55:50.050
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3966

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT * from getMinLines
					WHERE ln_rowid = 22074 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '10'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '10'
					AND a.ag_level2 = 'B'
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '10'
					AND a.ag_level2 = 'B'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotesNow (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
													SELECT * from getMyVotes WHERE
														(motion_rowid = 4794 OR motion_seq = 2)
												
getMyVotesNow (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
													SELECT * from getMyVotes WHERE
														(motion_rowid = 4795 OR motion_seq = 4)
												
getMyVotes (Datasource=, Time=0ms, Records=14) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT * from getAllVotes WHERE ln_rowid = 22075 
getMyMotions (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 1046 AND
											ln_rowid = 22075 
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
		SELECT meeting_id FROM minutes WHERE form_num = 1046 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 20:55:50.050
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3966

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT * from getMinLines
					WHERE ln_rowid = 22075 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '10'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '10'
					AND a.ag_level2 = 'C'
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '10'
					AND a.ag_level2 = 'C'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotesNow (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
													SELECT * from getMyVotes WHERE
														(motion_rowid = 4796 OR motion_seq = 2)
												
getMyVotesNow (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
													SELECT * from getMyVotes WHERE
														(motion_rowid = 4797 OR motion_seq = 4)
												
getMyVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT * from getAllVotes WHERE ln_rowid = 22076 
getMyMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 1046 AND
											ln_rowid = 22076 
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
		SELECT meeting_id FROM minutes WHERE form_num = 1046 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 20:55:50.050
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3966

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT * from getMinLines
					WHERE ln_rowid = 22076 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '10'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '10'
					AND a.ag_level2 = 'D'
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '10'
					AND a.ag_level2 = 'D'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT * from getAllVotes WHERE ln_rowid = 22077 
getMyMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 1046 AND
											ln_rowid = 22077 
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
		SELECT meeting_id FROM minutes WHERE form_num = 1046 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 20:55:50.050
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3966

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT * from getMinLines
					WHERE ln_rowid = 22077 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '10'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '10'
					AND a.ag_level2 = 'E'
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '10'
					AND a.ag_level2 = 'E'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT * from getAllVotes WHERE ln_rowid = 22065 
getMyMotions (Datasource=frsRO, Time=15ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 1046 AND
											ln_rowid = 22065 
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
		SELECT meeting_id FROM minutes WHERE form_num = 1046 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 20:55:50.050
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3966

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT * from getMinLines
					WHERE ln_rowid = 22065 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '11'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '11'
					AND a.ag_level2 = ''
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '11'
					AND a.ag_level2 = ''
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT * from getAllVotes WHERE ln_rowid = 22061 
getMyMotions (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 1046 AND
											ln_rowid = 22061 
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
		SELECT meeting_id FROM minutes WHERE form_num = 1046 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 20:55:50.050
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3966

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT * from getMinLines
					WHERE ln_rowid = 22061 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '12'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '12'
					AND a.ag_level2 = ''
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '12'
					AND a.ag_level2 = ''
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT * from getAllVotes WHERE ln_rowid = 22062 
getMyMotions (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 1046 AND
											ln_rowid = 22062 
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
		SELECT meeting_id FROM minutes WHERE form_num = 1046 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 20:55:50.050
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3966

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT * from getMinLines
					WHERE ln_rowid = 22062 
chkLevel1 (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '13'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '13'
					AND a.ag_level2 = ''
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 20:55:50.050
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 1046
					AND a.ag_level1 = '13'
					AND a.ag_level2 = ''
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMinLines (Datasource=frsRO, Time=47ms, Records=10) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
								SELECT a.cont_numbering, a.form_num minutes_form_num, am.form_num fas_form_num, am.ag_item_rowid,
									   ml._rowid ln_rowid, ml._rowid min_ln_rowid, ml.form_num, ml.seq_num,
									   am.ag_item_rowid, ml.ag_level1 chk_level1, ml.ag_level2 chk_level2, ml.ag_level3 chk_level3,
									   ml.ag_level1, ml.ag_level2, ml.ag_level3, ml.ag_level4, ml.disp_level, am.ainumber,
									   as1.sort_seq sort_level1, ml.ag_memo_id, ml.ag_memo_rev, c1.descr ag_time_descr,
									   fas.routing_apprvl fas_routing_apprvl, fas.final_apprvl fas_final_apprvl,
									   aa.item_type, aa.ag_area, ml.ag_subject,
									   c4.misc_alpha2 level_descriptor,
									   c2.misc_alpha7 lvl_text_size, c2.misc_alpha6 dp_level_ai, c3.long_descr px_size, c3.descr pdf_format,
											mt.agmemo_prefix, mt.agmemo_desc, a.disp_ainumber,
									   CASE WHEN am.ainumber = '' then '-1'
										WHEN am.ainumber = '0' then '-1'
										WHEN am.ainumber IS NULL then '-1'
								        ELSE am.ainumber END AS sort_memo2,
									    am.ag_item_rowid,
									   CASE WHEN ml.ag_level2 != '' AND ml.ag_level2 != '0' THEN as2.sort_seq ELSE -1 END AS sort_level2,
									   CASE WHEN ml.ag_level3 != '' AND ml.ag_level3 != '0' THEN as3.sort_seq ELSE -1 END AS sort_level3,
									   CASE WHEN ml.ag_level4 != '' AND ml.ag_level4 != '0' THEN as4.sort_seq ELSE -1 END AS sort_level4,
									   CASE WHEN ml.ag_memo_id IS NOT NULL THEN ml.ag_memo_id ELSE -1 END AS sort_memo,
									   CASE WHEN ml.ag_memo_id IS NOT NULL THEN am.ag_time ELSE ml.ag_time END as ag_time
								FROM minutes_ln ml
								INNER JOIN minutes a ON (a.form_num = ml.form_num AND a.rev_num = ml.rev_num)

								LEFT OUTER JOIN ag_memo AS am ON (am.form_num = ml.ag_memo_id AND am.rev_num = ml.ag_memo_rev)
								LEFT OUTER JOIN ag_template AS agt ON (agt.ag_template_id = a.ag_template_id)
								LEFT OUTER JOIN meeting_type AS mt ON (mt.meeting_type = agt.meeting_type)
								LEFT OUTER JOIN fas ON (fas.form_id = 'AG_MEMO' AND fas.form_num = am.form_num AND fas.rev_num = am.rev_num)
								
								LEFT OUTER JOIN ag_item AS ai ON (ai._rowid = am.ag_item_rowid)
								
								LEFT OUTER JOIN agenda_ln AS al ON (al.ag_memo_id = am.form_num AND al.ag_memo_rev = am.rev_num)
								LEFT OUTER JOIN ag_area AS aa ON (aa.meeting_type = agt.meeting_type AND aa.ag_area = ml.ag_area)          
								LEFT OUTER JOIN codes AS c1 ON (c1.code_type = 'AG TIME' and c1.valid_code = am.ag_time)
								LEFT OUTER JOIN alpha_sort AS as1 ON (as1.alpha_value = ml.ag_level1 AND CAST(as1.alpha_value AS binary(8)) = CAST(ml.ag_level1 AS binary(8)))
								LEFT OUTER JOIN alpha_sort AS as2 ON (as2.alpha_value = ml.ag_level2 AND CAST(as2.alpha_value AS binary(8)) = CAST(ml.ag_level2 AS binary(8)))
								LEFT OUTER JOIN alpha_sort AS as3 ON (as3.alpha_value = ml.ag_level3 AND CAST(as3.alpha_value AS binary(8)) = CAST(ml.ag_level3 AS binary(8)))
								LEFT OUTER JOIN alpha_sort AS as4 ON (as4.alpha_value = ml.ag_level4 AND CAST(as4.alpha_value AS binary(8)) = CAST(ml.ag_level4 AS binary(8)))
								LEFT OUTER JOIN codes AS c2 ON (c2.code_type = 'AddlMtg' and CAST(c2.valid_code AS INT) = a.meeting_id)
								LEFT OUTER JOIN codes AS c3 ON (c3.code_type = 'AG_FONT' and c3.valid_code = a.text_size)
								LEFT OUTER JOIN codes AS c4 ON (c4.code_type = 'MTG_MSG' and c4.valid_code = mt.meeting_type)
								WHERE ml.form_num = 1051
								ORDER BY sort_level1, sort_level2, sort_level3, sort_level4, sort_memo2, sort_memo, ln_rowid
							
checkVoteParent (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
							SELECT DISTINCT ag_area, item_type FROM getMinLines WHERE item_type = 'Y'
						
getAllVotes (Datasource=frsRO, Time=16ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
							SELECT mlv.form_num, ml.form_num minutes_form_num, ml._rowid min_ln_rowid,
									mlv.valid_code, mlv.motion_seq, mlv.seq_num, mlv.motion_rowid,
									ml.ag_memo_id, ml.ag_memo_rev, ml.ag_subject, mlm.motion_status, mlm.ln_rowid,
									c1.descr voteDescr, vote, c.descr, c1.long_descr vote_type, c1.misc_alpha abs_vote, tt.lname
							from minutes_ln_vote mlv
							INNER JOIN minutes_ln ml ON (ml._rowid = mlv.ln_rowid)
							INNER JOIN minutes_ln_motion mlm ON (mlm.ln_rowid = mlv.ln_rowid AND mlm.motion_seq = mlv.motion_seq)
							INNER JOIN codes c1 ON (c1.code_type = 'AG_VOTEOTHER' AND c1.valid_code = mlv.vote)
						
							LEFT OUTER JOIN codes c ON (c.code_type = 'AG_OFF' AND c.valid_code = mlv.valid_code)
							LEFT OUTER JOIN term_tracker tt ON (tt.code_rowid = c._rowid)
							LEFT OUTER JOIN codes c2 ON (c2.code_type = 'AG_OFF' AND c2.descr = tt.fname + ' ' + tt.lname and
									c2.valid_code = mlv.valid_code AND
									c2.large_misc_alpha = tt.meeting_type)
						    INNER JOIN minutes_roll mr ON (mr.form_num = mlv.form_num AND mr.name = c.descr AND c.large_misc_alpha = tt.meeting_type)
						
							WHERE mlv.form_num = 1051 
								AND (mlv.valid_code = c.valid_code OR c2.large_misc_alpha = c.large_misc_alpha)
							
							order by mlv.form_num, mlv.ln_rowid, mlv.motion_seq, mlv.seq_num, mlv.valid_code
						
totalVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
						SELECT voteDescr, count(voteDescr) voteCount
						FROM getAllVotes group by voteDescr
					
getMeetingVoters (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 20:55:50.050
							SELECT DISTINCT lname, valid_code, descr from getAllVotes
							WHERE form_num = 1051
							order by lname
						


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\inetpub\PublicPages\officials.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=10.20.10.48:8555
HTTP_REFERER=
HTTP_URL=//officials.cfm?seq=1046&report=MEETDATE&dt=2024-02-20%2000:00:00.0&SSTR=&GET_MONTH=4&LOGIN=&LOC=&DSP=&SUB=&ln=0&FP=&MT=ALL&GET_YEAR=2024&id=&StartRow=1
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.20.10.48
PATH_INFO=
PATH_TRANSLATED=D:\inetpub\PublicPages\officials.cfm
QUERY_STRING=seq=1046&report=MEETDATE&dt=2024-02-20%2000:00:00.0&SSTR=&GET_MONTH=4&LOGIN=&LOC=&DSP=&SUB=&ln=0&FP=&MT=ALL&GET_YEAR=2024&id=&StartRow=1
REMOTE_ADDR=10.20.230.5
REMOTE_HOST=10.20.230.5
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/officials.cfm
SERVER_NAME=10.20.10.48
SERVER_PORT=8555
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=
Client Variables:
cfid=9390360
cftoken=dd4dd89ef9ee9b1a-C3411C75-CA0E-D1BB-7CE101C74D89434B
hitcount=4
lastvisit={ts '2024-04-29 20:55:49'}
timecreated={ts '2024-04-29 20:55:49'}
urltoken=CFID=9390360&CFTOKEN=dd4dd89ef9ee9b1a-C3411C75-CA0E-D1BB-7CE101C74D89434B
Cookie Variables:
CFID=9390360
CFTOKEN=dd4dd89ef9ee9b1a-C3411C75-CA0E-D1BB-7CE101C74D89434B
Form Fields:
FROMDATE={ts '2023-04-29 20:55:49'}
FROMVOTEDATE={ts '2023-04-29 20:55:49'}
FROMVOTEYEAR=2023
MODE=
TODATE={ts '2024-04-29 20:55:49'}
TOVOTEDATE={ts '2024-04-29 20:55:49'}
Session Variables:
cfid=9390360
cftoken=dd4dd89ef9ee9b1a-C3411C75-CA0E-D1BB-7CE101C74D89434B
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9390360_dd4dd89ef9ee9b1a-C3411C75-CA0E-D1BB-7CE101C74D89434B
subdir=/public/
tzoffset=0
urltoken=CFID=9390360&CFTOKEN=dd4dd89ef9ee9b1a-C3411C75-CA0E-D1BB-7CE101C74D89434B
URL Parameters:
DSP=
FP=
GET_MONTH=4
GET_YEAR=2024
LOC=
LOGIN=
MT=ALL
SSTR=
SUB=
StartRow=1
dt=2024-02-20 00:00:00.0
id=
ln=0
report=MEETDATE
seq=1046
Debug Rendering Time: 15 ms